This .SQL file is the index to all marriage licenses filed in New York City for the years 1996-2017. This data was originally compiled by the New York City Clerk's Office.
Please note that this data is known to be somewhat incomplete, and there are some quality control problems with this database, including spelling mistakes and some malformed data. You can read more about those data quality issues, and search this entire file online for free, as well as an earlier data set for 1950-1995, at www.NYCMarriageIndex.com.
Where did this data come from?
In September 2017, the not-for-profit activist group Reclaim The Records made a New York State Freedom of Information Law (FOIL) request asking for a public copy of this data from the New York City Clerk's Office. The Clerk's Office refused to hand over the data, and were therefore eventually named in an "Article 78" lawsuit in the Supreme Court of New York in January 2018. The City eventually settled with Reclaim The Records in May 2018, and provided the data that was requested, as well as reimbursing their attorneys fees.
The data that the City Clerk's Office eventually provided were in the form of several .XLSX (Microsoft Excel) spreadsheet files, covering several years of data, but not broken down as to borough. Reclaim The Records turned these .XSLX files into some cleaned-up and concatenated .CSV files. Reclaim The Records then loaded those CSV files into a MySQL database with several tables, one for each file. An auto-incrementing 'id' field was added to each of the MySQL tables, as there was no unique or primary key in the files previously. This download is the .SQL file of that database and its tables. The XLSX files, the CSV files, and the SQL file are all in the public domain as public documents, and have all been uploaded to the Internet Archive. There are no restrictions on their use. Feel free to republish them, use them in projects, for personal research, or anything else you'd like.
To learn more about the backstory behind these files, and to read the request, the original court documents, and the settlement papers, click here. To read about an earlier lawsuit (also successful!) filed in 2016 for the 1950-1995 section of this data, click here.
June 12, 2018 Subject:
Thank you Brooke for all you do.
It is really appreciated by us in the "free to all" adoption & family searching community. Anyone needing FREE help finding a family member, go to Google & enter "G's Adoption Registry" http://www.gsadoptionregistry.com/ . Never a charge to find a family member. Also, we help on two other sites: http://www.the-seeker.com/relative.htm (FREE) & http://www.doenetwork.org/ (FREE help locating a missing person or identifying a dead person. To do it yourself, use David Gray's PeopleFinder for 11 days FREE http://18.104.22.168/login/register.pl?firstTime=1&affUSER= (costs about $2.95 a month after that & it is an historical database out of Texas. The money keeps in on the internet & that is the cheapest you will ever find anywhere.) I get NOTHING for saying any of this, so its not a damn ad, its FREE help. It costs you nothing.